How to: Print only selected records.
Solution:
Use the 'Print...' command under the 'File' menu, and select the 'Selected Records' radio button.
1) If the Database window is not active, activate the Database window.
2) Open the table in the Table Datasheet view.
3) Select the record(s) that are to be printed:
a) Place the cursor over the 'Row Selector' for the desired record. (The cursor turns into a down arrow.)
Row Selector
b) Press the mouse button. (The record is highlighted.)
NOTE 1: To select more than one adjacent record, press and hold down SHIFT while selecting the 'Row Selector' for each record.
NOTE 2: To select more than one non-adjacent record, press and hold down CTRL while selecting the 'Row Selector' for each record.
4) Select the 'File' menu and select 'Print...'. (The Print dialog box appears.)
5) Select the 'Selected Records' radio button in the 'Print Range' section.
Selected Records
6) Click 'OK'. (The selected record(s) are printed.)